<?php
	$sqlDBManager=new SqlDBManager();

	$startDate = date('dmy', strtotime($_SESSION["startDate"]));
	$endDate = date('dmy', strtotime($_SESSION["endDate"]));
	$userName = $_SESSION['username'];
	$centreName=$_SESSION['centreName'];

	if (!empty($_SESSION["userType"])) {
	    $userType = $_SESSION["userType"];
	}

	$sql = "Select Email from user where Username = ?";
	$parameters=array($userName);

	$res=$sqlDBManager->queryRow($sql,$parameters);

	if(!empty($res)){
		 $email = $res['Email'];
	}

	date_default_timezone_set('Asia/Singapore');

    //Create a new PHPMailer instance
    $mail = new PHPMailer();
    //Tell PHPMailer to use SMTP
    $mail->isSMTP();
    //Enable SMTP debugging
    // 0 = off (for production use)
    // 1 = client messages
    // 2 = client and server messages
    $mail->SMTPDebug = 0;
    //Ask for HTML-friendly debug output
    $mail->Debugoutput = 'html';
    //Set the hostname of the mail server
    $mail->Host = 'smtp.gmail.com';
    //Set the SMTP port number - 587 for authenticated TLS, a.k.a. RFC4409 SMTP submission
    $mail->Port = 587;
    //Set the encryption system to use - ssl (deprecated) or tls
    $mail->SMTPSecure = 'tls';
    //Whether to use SMTP authentication
    $mail->SMTPAuth = true;
    //Username to use for SMTP authentication - use full email address for gmail
    $mail->Username = EMAIL_ADDRESS;
    //Password to use for SMTP authentication
    $mail->Password = EMAIL_PASSWORD;
    //Set who the message is to be sent from
    $mail->setFrom(EMAIL_ADDRESS, 'NTUC Eldercare Centre IT Support Team');
    //Set who the message is to be sent to
    $mail->addAddress($email, $userName);
    //Set the subject line
	$mail->Subject = "Eldercare Monthly Attendance Report from " . $startDate . " to " . $endDate . " of ".$centreName." Centre";
    //Read an HTML message body from an external file, convert referenced images to embedded,
    //convert HTML into a basic plain-text alternative body
    $mail->msgHTML(file_get_contents('Reportsemail.html'), dirname(__FILE__));
    //Replace the plain text body with one created manually
    $mail->AltBody = 'This is a plain-text message body';
    //Attach an image file
    $attachmentName='../MonthlyReport/EldercareReport'.$startDate.'to'.$endDate.'-'.$centreName.'.xlsx';
	$mail->addAttachment($attachmentName);      // attachment

    $flagSuccess=0;
	if ($mail->Send()) {
        $flagSuccess=1;
	    echo json_encode(array('success'=>true));
	}else{
        echo json_encode(array('msg'=>"Mail Error: No Network or SMTP Time Out. Please try it later."));
    }
?>